{
 "cells": [
  {
   "cell_type": "code",
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-05-13T08:42:19.769702Z",
     "start_time": "2024-05-13T08:42:18.880046Z"
    }
   },
   "source": [
    "import pandas as pd\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import accuracy_score, f1_score\n",
    "\n",
    "from rulefit.rulefit import RuleFit"
   ],
   "outputs": [],
   "execution_count": 1
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-13T13:31:26.294039Z",
     "start_time": "2024-05-13T13:31:20.177858Z"
    }
   },
   "cell_type": "code",
   "source": [
    "data_df = pd.read_excel('../../all_data.xlsx')\n",
    "\n",
    "data_df"
   ],
   "id": "d0359887c98a2ae7",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "       是否为控股股东      质押市值（万元）     质押股数（万）  占所持股份比例（%）  占所总股本比例（%）  质押状态  \\\n",
       "0            0  5.178791e+05   5973.7200     13.6200      0.5100     2   \n",
       "1            0  9.216243e+05  18588.0000     42.3700      1.6000     2   \n",
       "2            0  1.005149e+06  10899.1900     89.1700      0.9400     2   \n",
       "3            0  6.366015e+05  12631.5789     28.7929      1.0861     2   \n",
       "4            0  6.366015e+05   7368.4211     16.7959      0.6335     2   \n",
       "...        ...           ...         ...         ...         ...   ...   \n",
       "25949        0  9.986491e+04    695.5000      4.4578      1.6196     0   \n",
       "25950        0  9.986491e+04    740.0000      4.7400      1.7200     0   \n",
       "25951        0  9.986491e+04   1120.3636      7.1800      2.6100     0   \n",
       "25952        0  1.112895e+05   4375.0000     28.0414      9.9522     0   \n",
       "25953        0  1.115965e+05    625.0000      4.0100      1.4200     0   \n",
       "\n",
       "       质押比例（%）  质押笔数  限售股质押股数（万）  非限售股质押股数（万）  ...  毛利率(%)  总资产报酬率(%)  \\\n",
       "0         3.04     4         0.0     29576.19  ...   20.46      0.640   \n",
       "1         5.64    16         0.0     54858.59  ...   20.46      0.640   \n",
       "2         5.47    17         0.0     53182.48  ...   18.87      0.074   \n",
       "3         3.13     9         0.0     30459.40  ...   22.94      0.578   \n",
       "4         3.13     9         0.0     30459.40  ...   22.94      0.578   \n",
       "...        ...   ...         ...          ...  ...     ...        ...   \n",
       "25949    34.41    15         0.0     14927.49  ...   60.46      0.968   \n",
       "25950    34.41    15         0.0     14927.49  ...   60.46      0.968   \n",
       "25951    34.41    15         0.0     14927.49  ...   60.46      0.968   \n",
       "25952    40.21    19         0.0     17443.49  ...   60.46      0.968   \n",
       "25953    41.03    19         0.0     17798.49  ...   60.46      0.968   \n",
       "\n",
       "       营业收入增长率(%)  总资产增长率(%)  营业利润增长率(%)  净利润增长率(%)  净资产增长率(%)  GDPg  CPIg  \\\n",
       "0          23.820     -3.066      10.234     10.643     -0.728   3.0  2.67   \n",
       "1          23.820     -3.066      10.234     10.643     -0.728   3.0  2.67   \n",
       "2           0.647      0.450      -1.863     10.579      0.389   4.8  1.10   \n",
       "3          14.186      4.594     -17.228    -11.678     -1.178   9.8  0.83   \n",
       "4          14.186      4.594     -17.228    -11.678     -1.178   9.8  0.83   \n",
       "...           ...        ...         ...        ...        ...   ...   ...   \n",
       "25949      10.766      3.955     -34.713    -17.648      1.748  -1.6  2.73   \n",
       "25950      10.766      3.955     -34.713    -17.648      1.748  -1.6  2.73   \n",
       "25951      10.766      3.955     -34.713    -17.648      1.748  -1.6  2.73   \n",
       "25952      10.766      3.955     -34.713    -17.648      1.748  -1.6  2.73   \n",
       "25953      10.766      3.955     -34.713    -17.648      1.748  -6.8  4.97   \n",
       "\n",
       "       PPIg  \n",
       "0      2.47  \n",
       "1      2.47  \n",
       "2      8.73  \n",
       "3      9.73  \n",
       "4      9.73  \n",
       "...     ...  \n",
       "25949 -3.27  \n",
       "25950 -3.27  \n",
       "25951 -3.27  \n",
       "25952 -3.27  \n",
       "25953 -0.60  \n",
       "\n",
       "[25954 rows x 34 columns]"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>是否为控股股东</th>\n",
       "      <th>质押市值（万元）</th>\n",
       "      <th>质押股数（万）</th>\n",
       "      <th>占所持股份比例（%）</th>\n",
       "      <th>占所总股本比例（%）</th>\n",
       "      <th>质押状态</th>\n",
       "      <th>质押比例（%）</th>\n",
       "      <th>质押笔数</th>\n",
       "      <th>限售股质押股数（万）</th>\n",
       "      <th>非限售股质押股数（万）</th>\n",
       "      <th>...</th>\n",
       "      <th>毛利率(%)</th>\n",
       "      <th>总资产报酬率(%)</th>\n",
       "      <th>营业收入增长率(%)</th>\n",
       "      <th>总资产增长率(%)</th>\n",
       "      <th>营业利润增长率(%)</th>\n",
       "      <th>净利润增长率(%)</th>\n",
       "      <th>净资产增长率(%)</th>\n",
       "      <th>GDPg</th>\n",
       "      <th>CPIg</th>\n",
       "      <th>PPIg</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>5.178791e+05</td>\n",
       "      <td>5973.7200</td>\n",
       "      <td>13.6200</td>\n",
       "      <td>0.5100</td>\n",
       "      <td>2</td>\n",
       "      <td>3.04</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29576.19</td>\n",
       "      <td>...</td>\n",
       "      <td>20.46</td>\n",
       "      <td>0.640</td>\n",
       "      <td>23.820</td>\n",
       "      <td>-3.066</td>\n",
       "      <td>10.234</td>\n",
       "      <td>10.643</td>\n",
       "      <td>-0.728</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.67</td>\n",
       "      <td>2.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>9.216243e+05</td>\n",
       "      <td>18588.0000</td>\n",
       "      <td>42.3700</td>\n",
       "      <td>1.6000</td>\n",
       "      <td>2</td>\n",
       "      <td>5.64</td>\n",
       "      <td>16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54858.59</td>\n",
       "      <td>...</td>\n",
       "      <td>20.46</td>\n",
       "      <td>0.640</td>\n",
       "      <td>23.820</td>\n",
       "      <td>-3.066</td>\n",
       "      <td>10.234</td>\n",
       "      <td>10.643</td>\n",
       "      <td>-0.728</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.67</td>\n",
       "      <td>2.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>1.005149e+06</td>\n",
       "      <td>10899.1900</td>\n",
       "      <td>89.1700</td>\n",
       "      <td>0.9400</td>\n",
       "      <td>2</td>\n",
       "      <td>5.47</td>\n",
       "      <td>17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53182.48</td>\n",
       "      <td>...</td>\n",
       "      <td>18.87</td>\n",
       "      <td>0.074</td>\n",
       "      <td>0.647</td>\n",
       "      <td>0.450</td>\n",
       "      <td>-1.863</td>\n",
       "      <td>10.579</td>\n",
       "      <td>0.389</td>\n",
       "      <td>4.8</td>\n",
       "      <td>1.10</td>\n",
       "      <td>8.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>6.366015e+05</td>\n",
       "      <td>12631.5789</td>\n",
       "      <td>28.7929</td>\n",
       "      <td>1.0861</td>\n",
       "      <td>2</td>\n",
       "      <td>3.13</td>\n",
       "      <td>9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30459.40</td>\n",
       "      <td>...</td>\n",
       "      <td>22.94</td>\n",
       "      <td>0.578</td>\n",
       "      <td>14.186</td>\n",
       "      <td>4.594</td>\n",
       "      <td>-17.228</td>\n",
       "      <td>-11.678</td>\n",
       "      <td>-1.178</td>\n",
       "      <td>9.8</td>\n",
       "      <td>0.83</td>\n",
       "      <td>9.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>6.366015e+05</td>\n",
       "      <td>7368.4211</td>\n",
       "      <td>16.7959</td>\n",
       "      <td>0.6335</td>\n",
       "      <td>2</td>\n",
       "      <td>3.13</td>\n",
       "      <td>9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30459.40</td>\n",
       "      <td>...</td>\n",
       "      <td>22.94</td>\n",
       "      <td>0.578</td>\n",
       "      <td>14.186</td>\n",
       "      <td>4.594</td>\n",
       "      <td>-17.228</td>\n",
       "      <td>-11.678</td>\n",
       "      <td>-1.178</td>\n",
       "      <td>9.8</td>\n",
       "      <td>0.83</td>\n",
       "      <td>9.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25949</th>\n",
       "      <td>0</td>\n",
       "      <td>9.986491e+04</td>\n",
       "      <td>695.5000</td>\n",
       "      <td>4.4578</td>\n",
       "      <td>1.6196</td>\n",
       "      <td>0</td>\n",
       "      <td>34.41</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14927.49</td>\n",
       "      <td>...</td>\n",
       "      <td>60.46</td>\n",
       "      <td>0.968</td>\n",
       "      <td>10.766</td>\n",
       "      <td>3.955</td>\n",
       "      <td>-34.713</td>\n",
       "      <td>-17.648</td>\n",
       "      <td>1.748</td>\n",
       "      <td>-1.6</td>\n",
       "      <td>2.73</td>\n",
       "      <td>-3.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25950</th>\n",
       "      <td>0</td>\n",
       "      <td>9.986491e+04</td>\n",
       "      <td>740.0000</td>\n",
       "      <td>4.7400</td>\n",
       "      <td>1.7200</td>\n",
       "      <td>0</td>\n",
       "      <td>34.41</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14927.49</td>\n",
       "      <td>...</td>\n",
       "      <td>60.46</td>\n",
       "      <td>0.968</td>\n",
       "      <td>10.766</td>\n",
       "      <td>3.955</td>\n",
       "      <td>-34.713</td>\n",
       "      <td>-17.648</td>\n",
       "      <td>1.748</td>\n",
       "      <td>-1.6</td>\n",
       "      <td>2.73</td>\n",
       "      <td>-3.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25951</th>\n",
       "      <td>0</td>\n",
       "      <td>9.986491e+04</td>\n",
       "      <td>1120.3636</td>\n",
       "      <td>7.1800</td>\n",
       "      <td>2.6100</td>\n",
       "      <td>0</td>\n",
       "      <td>34.41</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14927.49</td>\n",
       "      <td>...</td>\n",
       "      <td>60.46</td>\n",
       "      <td>0.968</td>\n",
       "      <td>10.766</td>\n",
       "      <td>3.955</td>\n",
       "      <td>-34.713</td>\n",
       "      <td>-17.648</td>\n",
       "      <td>1.748</td>\n",
       "      <td>-1.6</td>\n",
       "      <td>2.73</td>\n",
       "      <td>-3.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25952</th>\n",
       "      <td>0</td>\n",
       "      <td>1.112895e+05</td>\n",
       "      <td>4375.0000</td>\n",
       "      <td>28.0414</td>\n",
       "      <td>9.9522</td>\n",
       "      <td>0</td>\n",
       "      <td>40.21</td>\n",
       "      <td>19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17443.49</td>\n",
       "      <td>...</td>\n",
       "      <td>60.46</td>\n",
       "      <td>0.968</td>\n",
       "      <td>10.766</td>\n",
       "      <td>3.955</td>\n",
       "      <td>-34.713</td>\n",
       "      <td>-17.648</td>\n",
       "      <td>1.748</td>\n",
       "      <td>-1.6</td>\n",
       "      <td>2.73</td>\n",
       "      <td>-3.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25953</th>\n",
       "      <td>0</td>\n",
       "      <td>1.115965e+05</td>\n",
       "      <td>625.0000</td>\n",
       "      <td>4.0100</td>\n",
       "      <td>1.4200</td>\n",
       "      <td>0</td>\n",
       "      <td>41.03</td>\n",
       "      <td>19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17798.49</td>\n",
       "      <td>...</td>\n",
       "      <td>60.46</td>\n",
       "      <td>0.968</td>\n",
       "      <td>10.766</td>\n",
       "      <td>3.955</td>\n",
       "      <td>-34.713</td>\n",
       "      <td>-17.648</td>\n",
       "      <td>1.748</td>\n",
       "      <td>-6.8</td>\n",
       "      <td>4.97</td>\n",
       "      <td>-0.60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25954 rows × 34 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 7
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-13T08:42:26.084018Z",
     "start_time": "2024-05-13T08:42:26.069500Z"
    }
   },
   "cell_type": "code",
   "source": [
    "cols = data_df.columns.tolist()\n",
    "cols.remove(\"质押状态\")\n",
    "\n",
    "X, y = data_df[cols], data_df[\"质押状态\"]\n",
    "\n",
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.1, random_state=0)"
   ],
   "id": "1e8f56ad169622da",
   "outputs": [],
   "execution_count": 3
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-13T08:42:55.812942Z",
     "start_time": "2024-05-13T08:42:26.085020Z"
    }
   },
   "cell_type": "code",
   "source": [
    "rf = RuleFit(max_iter=20000, rfmode=\"classify\", random_state=0)\n",
    "rf.fit(X_train.values, y_train.values, feature_names=cols)\n",
    "y_pred = rf.predict(X_test.values)"
   ],
   "id": "47a42925a100afe6",
   "outputs": [],
   "execution_count": 4
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-13T08:42:55.828942Z",
     "start_time": "2024-05-13T08:42:55.813943Z"
    }
   },
   "cell_type": "code",
   "source": [
    "accuracy = accuracy_score(y_test, y_pred)\n",
    "f1 = f1_score(y_test, y_pred, average='macro')\n",
    "\n",
    "print(f\"{accuracy=},{f1=}\")"
   ],
   "id": "f425fbab9522edae",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "accuracy=0.88,f1=0.70060142099923\n"
     ]
    }
   ],
   "execution_count": 5
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-13T08:42:55.860941Z",
     "start_time": "2024-05-13T08:42:55.829942Z"
    }
   },
   "cell_type": "code",
   "source": [
    "rules = rf.get_rules()\n",
    "rules = rules[rules.coef != 0].sort_values(\"support\", ascending=False)\n",
    "rules[\"coef\"] = rules[\"coef\"].round(7)\n",
    "rules[\"support\"] = rules[\"support\"].round(2)\n",
    "\n",
    "rules"
   ],
   "id": "23ebe75967c84f39",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                                                   rule    type      coef  \\\n",
       "3                                            占所持股份比例（%）  linear -0.024453   \n",
       "19                                           固定资产周转率(次)  linear  0.030154   \n",
       "28                                            净利润增长率(%)  linear  0.000107   \n",
       "27                                           营业利润增长率(%)  linear  0.000223   \n",
       "25                                           营业收入增长率(%)  linear  0.000035   \n",
       "...                                                 ...     ...       ...   \n",
       "763   流动资产周转率(次) > 0.5800000131130219 & 应收账款周转率(次) <...    rule -0.934951   \n",
       "1320  质押市值（万元） > 138670.2578125 & 质押股数（万） <= 8784.0 ...    rule  1.099552   \n",
       "1829  应收账款周转率(次) > 0.5305000245571136 & 质押比例（%） > 20...    rule -3.968903   \n",
       "1519  固定资产周转率(次) <= 66.30249977111816 & 存货周转率(次) <= ...    rule  0.400236   \n",
       "1156         质押市值（万元） <= 146101.09375 & 质押股数（万） <= 47.5    rule -2.185485   \n",
       "\n",
       "      support  \n",
       "3        1.00  \n",
       "19       1.00  \n",
       "28       1.00  \n",
       "27       1.00  \n",
       "25       1.00  \n",
       "...       ...  \n",
       "763      0.01  \n",
       "1320     0.01  \n",
       "1829     0.01  \n",
       "1519     0.00  \n",
       "1156     0.00  \n",
       "\n",
       "[541 rows x 4 columns]"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>rule</th>\n",
       "      <th>type</th>\n",
       "      <th>coef</th>\n",
       "      <th>support</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>占所持股份比例（%）</td>\n",
       "      <td>linear</td>\n",
       "      <td>-0.024453</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>固定资产周转率(次)</td>\n",
       "      <td>linear</td>\n",
       "      <td>0.030154</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>净利润增长率(%)</td>\n",
       "      <td>linear</td>\n",
       "      <td>0.000107</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>营业利润增长率(%)</td>\n",
       "      <td>linear</td>\n",
       "      <td>0.000223</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>营业收入增长率(%)</td>\n",
       "      <td>linear</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>流动资产周转率(次) &gt; 0.5800000131130219 &amp; 应收账款周转率(次) &lt;...</td>\n",
       "      <td>rule</td>\n",
       "      <td>-0.934951</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1320</th>\n",
       "      <td>质押市值（万元） &gt; 138670.2578125 &amp; 质押股数（万） &lt;= 8784.0 ...</td>\n",
       "      <td>rule</td>\n",
       "      <td>1.099552</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1829</th>\n",
       "      <td>应收账款周转率(次) &gt; 0.5305000245571136 &amp; 质押比例（%） &gt; 20...</td>\n",
       "      <td>rule</td>\n",
       "      <td>-3.968903</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1519</th>\n",
       "      <td>固定资产周转率(次) &lt;= 66.30249977111816 &amp; 存货周转率(次) &lt;= ...</td>\n",
       "      <td>rule</td>\n",
       "      <td>0.400236</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1156</th>\n",
       "      <td>质押市值（万元） &lt;= 146101.09375 &amp; 质押股数（万） &lt;= 47.5</td>\n",
       "      <td>rule</td>\n",
       "      <td>-2.185485</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>541 rows × 4 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 6
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
